<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<title>text_columns: common_schema documentation</title>
	<meta name="description" content="text_columns: common_schema" />
	<meta name="keywords" content="text_columns: common_schema" />
	<link rel="stylesheet" type="text/css" href="css/style.css" />
</head>

<body>
	<div id="main">
		<div id="header">
			<h1>common_schema</h1> <strong>2.2</strong> documentation
			<div class="subtitle">DBA's framework for MySQL</div>
		</div>
		<div id="contentwrapper">
			<div id="content">
				<h2><a href="text_columns.html">text_columns</a></h2>	
<h3>NAME</h3>
text_columns: list textual columns character sets & collations
<h3>TYPE</h3>
View

<h3>DESCRIPTION</h3>

<p><i>text_columns</i> builds upon INFORMATION_SCHEMA's COLUMNS table to present with 
textual columns, their character sets and collations.
</p>

<p>Textual columns are columns of types <strong>CHAR</strong>, <strong>VARCHAR</strong>, <strong>TINYTEXT</strong>, <strong>MEDIUMTEXT</strong>, <strong>TEXT</strong>, <strong>LONGTEXT</strong>.
</p>

<p><strong>ENUM</strong> and <strong>SET</strong> types are excluded, although they, too, are associated with character sets and collations.
Internal representation of <strong>ENUM</strong> & <strong>SET</strong> is numeric.</p>

<h3>STRUCTURE</h3>

<blockquote><pre>
mysql&gt; DESC common_schema.text_columns;
+--------------------+-------------+------+-----+---------+-------+
| Field              | Type        | Null | Key | Default | Extra |
+--------------------+-------------+------+-----+---------+-------+
| TABLE_SCHEMA       | varchar(64) | NO   |     |         |       |
| TABLE_NAME         | varchar(64) | NO   |     |         |       |
| COLUMN_NAME        | varchar(64) | NO   |     |         |       |
| COLUMN_TYPE        | longtext    | NO   |     | NULL    |       |
| CHARACTER_SET_NAME | varchar(32) | YES  |     | NULL    |       |
| COLLATION_NAME     | varchar(32) | YES  |     | NULL    |       |
+--------------------+-------------+------+-----+---------+-------+
</pre></blockquote>

<h3>SYNOPSIS</h3>

<p>Columns of this view directly map to those of <a href="http://dev.mysql.com/doc/refman/5.1/en/columns-table.html">INFORMATION_SCHEMA.COLUMNS</a></p>

<h3>EXAMPLES</h3>
<blockquote><pre>mysql&gt; SELECT * FROM common_schema.text_columns WHERE TABLE_SCHEMA IN ('sakila', 'world');
+--------------+----------------------------+----------------+--------------+--------------------+-------------------+
| TABLE_SCHEMA | TABLE_NAME                 | COLUMN_NAME    | COLUMN_TYPE  | CHARACTER_SET_NAME | COLLATION_NAME    |
+--------------+----------------------------+----------------+--------------+--------------------+-------------------+
| sakila       | actor                      | first_name     | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | actor                      | last_name      | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | actor_info                 | first_name     | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | actor_info                 | last_name      | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | actor_info                 | film_info      | longtext     | utf8               | utf8_general_ci   |
| sakila       | address                    | address        | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | address                    | address2       | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | address                    | district       | varchar(20)  | utf8               | utf8_general_ci   |
| sakila       | address                    | postal_code    | varchar(10)  | utf8               | utf8_general_ci   |
| sakila       | address                    | phone          | varchar(20)  | utf8               | utf8_general_ci   |
| sakila       | category                   | name           | varchar(25)  | utf8               | utf8_general_ci   |
| sakila       | city                       | city           | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | country                    | country        | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | customer                   | first_name     | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | customer                   | last_name      | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | customer                   | email          | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | name           | varchar(91)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | address        | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | zip code       | varchar(10)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | phone          | varchar(20)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | city           | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | country        | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | customer_list              | notes          | varchar(6)   | utf8               | utf8_general_ci   |
| sakila       | film                       | title          | varchar(255) | utf8               | utf8_general_ci   |
| sakila       | film                       | description    | text         | utf8               | utf8_general_ci   |
| sakila       | film_list                  | title          | varchar(255) | utf8               | utf8_general_ci   |
| sakila       | film_list                  | description    | text         | utf8               | utf8_general_ci   |
| sakila       | film_list                  | category       | varchar(25)  | utf8               | utf8_general_ci   |
| sakila       | film_list                  | actors         | longtext     | utf8               | utf8_general_ci   |
| sakila       | film_text                  | title          | varchar(255) | utf8               | utf8_general_ci   |
| sakila       | film_text                  | description    | text         | utf8               | utf8_general_ci   |
| sakila       | language                   | name           | char(20)     | utf8               | utf8_general_ci   |
| sakila       | nicer_but_slower_film_list | title          | varchar(255) | utf8               | utf8_general_ci   |
| sakila       | nicer_but_slower_film_list | description    | text         | utf8               | utf8_general_ci   |
| sakila       | nicer_but_slower_film_list | category       | varchar(25)  | utf8               | utf8_general_ci   |
| sakila       | nicer_but_slower_film_list | actors         | longtext     | utf8               | utf8_general_ci   |
| sakila       | sales_by_film_category     | category       | varchar(25)  | utf8               | utf8_general_ci   |
| sakila       | sales_by_store             | store          | varchar(101) | utf8               | utf8_general_ci   |
| sakila       | sales_by_store             | manager        | varchar(91)  | utf8               | utf8_general_ci   |
| sakila       | staff                      | first_name     | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | staff                      | last_name      | varchar(45)  | utf8               | utf8_general_ci   |
| sakila       | staff                      | email          | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | staff                      | username       | varchar(16)  | utf8               | utf8_general_ci   |
| sakila       | staff                      | password       | varchar(40)  | utf8               | utf8_bin          |
| sakila       | staff_list                 | name           | varchar(91)  | utf8               | utf8_general_ci   |
| sakila       | staff_list                 | address        | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | staff_list                 | zip code       | varchar(10)  | utf8               | utf8_general_ci   |
| sakila       | staff_list                 | phone          | varchar(20)  | utf8               | utf8_general_ci   |
| sakila       | staff_list                 | city           | varchar(50)  | utf8               | utf8_general_ci   |
| sakila       | staff_list                 | country        | varchar(50)  | utf8               | utf8_general_ci   |
| world        | City                       | Name           | char(35)     | latin1             | latin1_swedish_ci |
| world        | City                       | CountryCode    | char(3)      | latin1             | latin1_swedish_ci |
| world        | City                       | District       | char(20)     | latin1             | latin1_swedish_ci |
| world        | Country                    | Code           | char(3)      | latin1             | latin1_swedish_ci |
| world        | Country                    | Name           | char(52)     | latin1             | latin1_swedish_ci |
| world        | Country                    | Region         | char(26)     | latin1             | latin1_swedish_ci |
| world        | Country                    | LocalName      | char(45)     | latin1             | latin1_swedish_ci |
| world        | Country                    | GovernmentForm | char(45)     | latin1             | latin1_swedish_ci |
| world        | Country                    | HeadOfState    | char(60)     | latin1             | latin1_swedish_ci |
| world        | Country                    | Code2          | char(2)      | latin1             | latin1_swedish_ci |
| world        | CountryLanguage            | CountryCode    | char(3)      | latin1             | latin1_swedish_ci |
| world        | CountryLanguage            | Language       | char(30)     | latin1             | latin1_swedish_ci |
+--------------+----------------------------+----------------+--------------+--------------------+-------------------+
</pre></blockquote>

<h3>ENVIRONMENT</h3>
MySQL 5.1 or newer.

<h3>SEE ALSO</h3>
<a href="table_charset.html">table_charset</a>

<h3>AUTHOR</h3>
Shlomi Noach
				<br/>
			</div>
			<div id="sidebarwrapper">
				<div id="search">
					Search online documentation
					<form id="search_form" name="search_form" method="GET" 
						action="http://www.google.com/search" 
						onsubmit="document.forms['search_form']['q'].value = 'site:http://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/ '+document.forms['search_form']['search_term'].value;">
						<input type="text" name="search_term" value=""/>
						<input type="hidden" name="q" value=""/>
						<input type="submit" value="go"/>						
					</form>
				</div>
				<div id="menu">
					<ul>
						<li><a title="Introduction" href="introduction.html">Introduction</a></li>
						<li><a title="Documentation" href="documentation.html">Documentation</a></li>
						<li><a title="Download" href="download.html">Download</a></li>
						<li><a title="Install" href="install.html">Install</a></li>
						<li><a title="Risks" href="risks.html">Risks</a></li>
					</ul>						
					<h3>QUERY SCRIPT</h3>
					<ul>
						<li><a title="QueryScript" href="query_script.html">QueryScript</a></li>
						<li><a title="Execution" href="query_script_execution.html">Execution</a></li>
						<li><a title="Flow control" href="query_script_flow_control.html">Flow control</a></li>
						<li><a title="Statements" href="query_script_statements.html">Statements</a></li>
						<li><a title="Expressions" href="query_script_expressions.html">Expressions</a></li>
						<li><a title="Variables" href="query_script_variables.html">Variables</a></li>
					</ul>						
					<h3>DEBUG</h3>
					<ul>
						<li><a title="rdebug" href="rdebug.html">rdebug</a></li>
						<li><a title="rdebug API" href="rdebug_api.html">rdebug API</a></li>
						<li><a title="rdebug workflow" href="rdebug_workflow.html">Workflow</a></li>
					</ul>						
					<h3>ROUTINES</h3>
					<ul>
						<li><a title="Execution &amp; flow control" href="execution_routines.html">Execution & flow control</a></li>
						<li><a title="General" href="general_routines.html">General</a></li>
						<li><a title="Process" href="process_routines.html">Process</a></li>
						<li><a title="Query analysis" href="query_analysis_routines.html">Query analysis</a></li>
						<li><a title="Schema analysis" href="schema_analysis_routines.html">Schema analysis</a></li>
						<li><a title="Security" href="security_routines.html">Security</a></li>
						<li><a title="Text" href="text_routines.html">Text</a></li>
						<li><a title="Time &amp; date" href="temporal_routines.html">Time & date</a></li>
						<li><a title="Charting" href="charting_routines.html">Charting</a></li>
					</ul>
					<h3>VIEWS</h3>
					<ul>
						<li><a title="Schema analysis" href="schema_analysis_views.html">Schema analysis</a></li>
						<li><a title="Data dimension" href="data_dimension_views.html">Data dimension</a></li>
						<li><a title="Process" href="process_views.html">Process</a></li>
						<li><a title="Security" href="security_views.html">Security</a></li>
						<li><a title="Monitoring" href="monitoring_views.html">Monitoring</a></li>
						<li><a title="InnoDB Plugin" href="innodb_plugin_views.html">InnoDB Plugin</a></li>
						<li><a title="Percona server" href="percona_server_views.html">Percona Server</a></li>
						<li><a title="TokuDB" href="tokudb_views.html">TokuDB</a></li>
					</ul>						
					<h3>DATA</h3>
					<ul>
						<li><a title="tables" href="tables.html">Tables</a></li>
						<li><a title="variables" href="variables.html">Variables</a></li>
					</ul>						
					<h3>META</h3>
					<ul>
						<li><a title="Help" href="help.html">help</a></li>
						<li><a title="Metadata" href="metadata.html">metadata</a></li>
						<li><a title="status" href="status.html">status</a></li>
					</ul>						
				</div>
			</div>	
			<div class="clear">&nbsp;</div>
			
			<div id="footnote" align="center">
				<a href="">common_schema</a> documentation
			</div>
		</div>
	</div>
</body>
</html>
